#!/bin/bash


#awk  -F,   '{print $1}'  'ETICKET_ALLINPAY_01POS_990611063006000_20230410_0001.txt'



vsp_txt="ETICKET_ALLINPAY_01POS_990611063006000_20230410_0001.txt"

trans_date="20230410"

awk  -F,  -v trans_date=$trans_date  '{ OFS=",";   $5 = trans_date$5; print $0}'  $vsp_txt   >  sql.txt














